Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
- Downloads：1766
- Type：Epub+TxT+PDF+Mobi
- Create Date：2021-08-21 09:53:57
- Update Date：2025-09-06
- Status：finish
- Author：Michael J. Hernandez
- ISBN：0321884493
- Environment：PC/Android/iPhone/iPad/Kindle
- Download
Summary
Learn database design the easy， common-sense way！ For years， Michael J。 Hernandez's best selling Database Design for Mere Mortals® has earned worldwide respect as the clearest， most straightforward， software-independent tutorial on the basic principles of relational database design。 Now， he's thoroughly updated this hands-on best-seller， making it even easier to understand and use， while thoroughly updating its coverage for today's databases and design best practices。 Database Design for Mere Mortals， Third Edition opens with a completely new first chapter， and text and figures have been revised throughout for even greater clarity and simplicity。 Updates also include new content explaining normalization and showing how to transparently incorporate it into database design; updated and improved coverage of data types; and extensive new support for instructional use， including spec sheets in the form of Word document templates; PowerPoint slide decks; and new test questions for instructors。 Database Design for Mere Mortals， Third Edition delivers foundational， software-independent knowledge you can use immediately to start solving real-world problems immediately， and offers a smooth learning curve that prepares you to learn more advanced skills whenever you're ready！
Reviews
Sean Rich
，
Rather antiquated。 Couldn’t bring myself to finish it so who knows it might’ve gotten better。
Reinis Bekeris
，
Really good base to put in before attempting to build a database。 Highly recommend！ Only 4 stars because at leats 20% of the content is just restating what was written before and not even paraphrasing。 Also the summary is rather dry and could use some more visual aid instead of list that states exactly what was written in the chapter。
Nick
，
Database Design For Mere Mortals is an unusual book。 Most database books describe how to use a particular piece of database software， but give little attention to high-level design of how the data ought to be structured。 DDFMM takes the opposite approach: it shows you how to go from a set of ambiguous， half-specified requirements， and go to an unambiguous database model。The first edition of DDFMM was published in 1996， but it has aged remarkably well for a technical book。 Aside from references t Database Design For Mere Mortals is an unusual book。 Most database books describe how to use a particular piece of database software， but give little attention to high-level design of how the data ought to be structured。 DDFMM takes the opposite approach: it shows you how to go from a set of ambiguous， half-specified requirements， and go to an unambiguous database model。The first edition of DDFMM was published in 1996， but it has aged remarkably well for a technical book。 Aside from references to Oracle SQL and Waterfall Methodology， it could have been published yesterday。DDFMM has three central claims。First， it is useful to spend time designing your database， to make sure that you are tracking the right things， and that your data is represented in the simplest way。 If you skip this step， you are pushing work onto the application， which makes designing and maintaining it more complicated。Second， it is important to create constraints to prevent invalid data from being entered。 Data can enter the database through multiple routes， and enforcing correctness at the database level is easier than doing it in each individual application。Third， the database should be designed to avoid storing the same data in multiple places。 If a customer phone number is stored in multiple places， then the application needs to update each copy of the phone number whenever it is changed。 This makes the application more complicated。DDFMM is very clearly written and well-polished。 For every concept， there are two or three concrete examples to motivate and illustrate the concept。 However， it is also very repetitive and redundant， which makes it a slog to get through。 。。。more
L
，
This book was a good review in database design。 I liked the way it broken design into laymen terms instead of the usual academic approach。
Joshua
，
The book has been with me for some time。 I decided to recommit to reading through it。 I am proud of such an accomplishment。 What sparks joy for me is database design。 I own it。 Database design may be an odd pleasure for most。 There is a beauty to order and the greatest insight information provides。 For me。 I have taken courses on database design。 Watched videos。 I find this book one of the most effective learning tools I have encountered thus far on Database Design。 I am fearlessly ready to appl The book has been with me for some time。 I decided to recommit to reading through it。 I am proud of such an accomplishment。 What sparks joy for me is database design。 I own it。 Database design may be an odd pleasure for most。 There is a beauty to order and the greatest insight information provides。 For me。 I have taken courses on database design。 Watched videos。 I find this book one of the most effective learning tools I have encountered thus far on Database Design。 I am fearlessly ready to apply all I have read here。 That feels so empowering。 Imagine the usefulness of the content， tv show， social media or book to come to your life and then give you the expertise to effect meaningful change。 This book is that for me。 We need reasons to enjoy life。 To find a purpose and apply oneself in the work you believe able to dedicate oneself deeply to is a gift。 I appreciate the author tremendously in his work。 。。。more
Uriel Vidal
，
Es un libro muy educativo acerca del diseño de bases de datos y parte del objetivo del autor es hacer muy detallista en las explicaciones para llegar a un público más grande。 Es precisamente esto donde el está el aparente problema del libro y es que resulta algo tedioso que una explicación simple， resulte en páginas y páginas detallando un ejemplo y al final el proceso resulte más grande de lo que aparentemente es。Al final genera una explicación acerca de los modos normalizados y como es que lle Es un libro muy educativo acerca del diseño de bases de datos y parte del objetivo del autor es hacer muy detallista en las explicaciones para llegar a un público más grande。 Es precisamente esto donde el está el aparente problema del libro y es que resulta algo tedioso que una explicación simple， resulte en páginas y páginas detallando un ejemplo y al final el proceso resulte más grande de lo que aparentemente es。Al final genera una explicación acerca de los modos normalizados y como es que llegó a su forma de trabajo， necesario llegar a leer esa parte para comprender como es que su forma funciona。También coloca libros sugeridos que a mi parecer hace que un libro generé la confianza para saber que tiene continuidad y no representa la verdad absoluta。 。。。more
Matt Kowalczyk
，
Good guide on creating a normalized database design with best practices。 Avoids going dow the rabbit hole of database/set theory and allows you to get the job done。
Piotr
，
Good book for the people who know absolutely nothing about databases。 For someone with a least a basic knowledge a bit too lengthy for the value offered。 Author explains step by step how the database should be designed describing each step very （very） thoroughly。 After reading "SQL queries for mere mortals" I expected much more practical exercises and real world examples。 In fact I think that the short introduction to the databases presented in that book had much higher value to text ratio。 Good Good book for the people who know absolutely nothing about databases。 For someone with a least a basic knowledge a bit too lengthy for the value offered。 Author explains step by step how the database should be designed describing each step very （very） thoroughly。 After reading "SQL queries for mere mortals" I expected much more practical exercises and real world examples。 In fact I think that the short introduction to the databases presented in that book had much higher value to text ratio。 Good thing is that you can read it quite quickly。 I'd still recommend it to someone who is at the very beginning of the database adventure。 。。。more
Emily
，
A bit dryer in tone than my other textbook for database design， and with no hands-on practice， this book was still a helpful guide to learning the theory and best practices of relational database design。 The chapters are laid out logically， and the explanations are clear。 Lots of visuals are provided too， which I really value。 Each chapter has a helpful summary at the end and questions to quiz yourself。 This is a good book for beginners and would be worthwhile to keep as a reference。
Andrew
，
Rather lengthy， but a great process for developing a relational database and its documentation。
Alexa Williams
，
Ehhhhh， does its job， but it's about 100 pages longer than it needs to be。 Ehhhhh， does its job， but it's about 100 pages longer than it needs to be。 。。。more
Tommy Estlund
，
If you're interested in database design。。。read this book。 If you're not？ Well， you're probably safe not reading it。 If you're interested in database design。。。read this book。 If you're not？ Well， you're probably safe not reading it。 。。。more
Marcos Moret
，
Easy to follow
Chris Navy
，
for the tldr people:Tables， tables， tables。 Good table design makes for a good database！
Gena
，
Simple to read， practical and straightforward。 ideal to start with Database Design。
أحمد حسان
，
من أفضل ما تقرأ عن تصميم قواعد البيانات خصوصا ما يعرف ب Database Modeling أفضل جزء فى الكتاب هو ال Sheets التى فيها المعايير التى تطبق على كل جدول وعلى العلاقات بين الجداول كنت أود نسخة ورقية منه ستكون أسهل فى المتابعة
Gail
，
I'll have to say， I'd have to think long and hard before I would embark on designing a database。 It's so much easier to just work with what you have and hassle a DBA to fix it for you。 This book does give you a very clear， factual way to go about the process of designing a database。 I'll have to say， I'd have to think long and hard before I would embark on designing a database。 It's so much easier to just work with what you have and hassle a DBA to fix it for you。 This book does give you a very clear， factual way to go about the process of designing a database。 。。。more
Kylie Sparks
，
I'm a non-techie and I managed to read and understand this entire book--I think that's quite a feat for a technical textbook。 I'm a non-techie and I managed to read and understand this entire book--I think that's quite a feat for a technical textbook。 。。。more
Brendan
，
Nice primer written for the layman。 Now if I could only put this material into practice！
Libby
，
Update （11/16/12）: halfway through。 author has spent a whole lot of time hand-holding through interview techniques， when I wanted to be hand-held through design principles。 I'm also peeved that of all the fake characters I've read about， the only two females were （1） a nagging wife， and （2） an assistant named Kendra。 None of the business owners， management team， database developers， etc。 The upside is that it was written in 1997 and so contains some beautiful passages like:p。 80 "He owns a compu Update （11/16/12）: halfway through。 author has spent a whole lot of time hand-holding through interview techniques， when I wanted to be hand-held through design principles。 I'm also peeved that of all the fake characters I've read about， the only two females were （1） a nagging wife， and （2） an assistant named Kendra。 None of the business owners， management team， database developers， etc。 The upside is that it was written in 1997 and so contains some beautiful passages like:p。 80 "He owns a computer but uses it mainly to play games， write letters， and "surf the 'net。"p。 94 "When they are satisfied that they understand the mission objectives and that the list is relatively complete， commit the list to a document in your favorite word processor and save it for later use。"Update （Fall 2012）: Found it under my bed。 Awesome。Original （Spring 2012）: I don't know where this went！ I bought it in the first week of January and put it down and now it's not anywhere。 Man！ 。。。more
John Moss
，
Good basic database design book， but Database Normalization is not covered。 Strange。
Mark
，
Although this took me longer to get through than I anticipated （other things kept intervening）， I'm glad I stuck with it。 Although I've had a bit of formal training on databases in various classes and "webinars，" most of my knowledge is from accumulated experience， and therefore not always terribly well-structured。 'Database Design for Mere Mortals' helped me restructure what I know and place it against a larger framework of design methodology。 The writing is clear and concise， and well-provided Although this took me longer to get through than I anticipated （other things kept intervening）， I'm glad I stuck with it。 Although I've had a bit of formal training on databases in various classes and "webinars，" most of my knowledge is from accumulated experience， and therefore not always terribly well-structured。 'Database Design for Mere Mortals' helped me restructure what I know and place it against a larger framework of design methodology。 The writing is clear and concise， and well-provided with practical examples。I will be looking for ways to implement some of the insights I gained from reading it。。。 it's already enabled me to identify some of the design-related problems we're currently experiencing at our company。 Although I may not ever have a real chance to design a database from the ground up （that's not really my job）， I have a much more complete appreciation of what's involved （and what ought to be involved）。 。。。more
Jane
，
Keeping this one， just in case， someday， I build or design a DB for real。 For some reason。
Ruth
，
Very useful book， good textbook for the course I was taking。
Daniel
，
Decent book for someone who doesn't want or have to live and breathe databases。 Decent book for someone who doesn't want or have to live and breathe databases。 。。。more
Louis
，
This was very good as a hands on book。 I used it for teaching。 Several of the students said they liked it because it was more hands on。 I felt that it was a bit light on the theory。 But it probably gets paired very well with books that are deeper in the how and why because Hernandez does a good job of explaining concepts in english。 Also， there were some sections （like diagramming） that I felt that Hernandez was much better then alternatives， because instead of using the full set of UML， he uses This was very good as a hands on book。 I used it for teaching。 Several of the students said they liked it because it was more hands on。 I felt that it was a bit light on the theory。 But it probably gets paired very well with books that are deeper in the how and why because Hernandez does a good job of explaining concepts in english。 Also， there were some sections （like diagramming） that I felt that Hernandez was much better then alternatives， because instead of using the full set of UML， he uses a subset that makes sense for what he needs。 And this attitude is applied to other topics as well。 。。。more
Zack
，
I didn't finish it， it's a little over my head， but maybe I'll try again in the future。 I didn't finish it， it's a little over my head， but maybe I'll try again in the future。 。。。more
Jeff
，
Mike's a friend of mine who works at Microsoft。 Mike's a friend of mine who works at Microsoft。 。。。more
Kim
，
Someone buy this for me！
Lynn
，